

function guidToBinData(guid) { 
    guid = guid.replace(/[{}-]/g, "");
    var field1 = guid.substr(0, 8); 
    var field2 = guid.substr(8, 4); 
    var field3 = guid.substr(12, 4); 
    var field4 = guid.substr(16, 4); 
    var field5 = guid.substr(20, 12); 
    field1 = field1.substr(6, 2) + field1.substr(4, 2) + field1.substr(2, 2) + field1.substr(0, 2) 
    field2 = field2.substr(2, 2) + field2.substr(0, 2) 
    field3 = field3.substr(2, 2) + field3.substr(0, 2) 
    var hex = field1 + field2 + field3 + field4 + field5;

    // convert hex to base64 
    var base64Digits = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/";
    var base64 = ""; 
    var group; 
    for (var i = 0; i < 30; i += 6) { 
        group = parseInt(hex.substr(i, 6), 16); 
        base64 += base64Digits[(group >> 18) & 0x3f]; 
        base64 += base64Digits[(group >> 12) & 0x3f]; 
        base64 += base64Digits[(group >> 6) & 0x3f]; 
        base64 += base64Digits[group & 0x3f]; 
    } 
    group = parseInt(hex.substr(30, 2), 16); 
    base64 += base64Digits[(group >> 2) & 0x3f]; 
    base64 += base64Digits[(group << 4) & 0x3f]; 
    base64 += "=="; 

    return new BinData(3,base64); 
} 



 db.InsightSectorName.drop();
 db.InsightSectorName.insert([

         { _id: guidToBinData('{C26482C5-7F0F-46D6-8164-0C0A689B2B9D}'), Name: "Consumer Staples" },
         { _id: guidToBinData('{07AE3CD3-68A8-47BE-BEAD-47F50DC67711}'), Name: "Telecommunication" },
         { _id: guidToBinData('{1792672A-CDCA-49C6-BEE4-833BBCC4E583}'), Name: "Services" },
         { _id: guidToBinData('{C1C7078B-C323-4D1F-B7ED-B503B1FA2029}'), Name: "Industrials" },
         { _id: guidToBinData('{C8A681C1-39AB-44B9-BF5D-21588EA36B5F}'), Name: "Information Technology" },
         { _id: guidToBinData('{C6C39387-6565-4355-AABB-251178ACAA8B}'), Name: "Energy" },
         { _id: guidToBinData('{B0F158C6-362F-49EF-A2C3-BED1038D02A9}'), Name: "Financials" },
         { _id: guidToBinData('{D5DA98D2-90BF-4D31-B87C-5F70C6C39F4D}'), Name: "Healthcare" },
         { _id: guidToBinData('{4D1D1803-336E-40F9-BA17-97A23038222D}'), Name: "Materials" },
         { _id: guidToBinData('{06712FFF-6648-46ED-A42F-4A655109A4BB}'), Name: "Utilities" }
     ],
     { ordered: true }
 );

 db.InsightTopicName.drop();
 db.InsightTopicName.insert([

         { _id: guidToBinData('{5D268861-BE97-4DD5-B76B-A387E61B1F5B}'), Name: "Asia and Emerging Markets" },
         { _id: guidToBinData('{787A7F66-47AE-451B-9928-01A603480802}'), Name: "Climate Change" },
         { _id: guidToBinData('{CB739097-411C-4C30-9307-405A7CF7C335}'), Name: "Corporate Sustainability Performance" },
         { _id: guidToBinData('{A822C2BF-7F9C-4651-847B-2654BBC3CC3A}'), Name: "Embargoes and Sanctions" },
         { _id: guidToBinData('{EDE5091D-15CB-4841-8925-EDF40690EA00}'), Name: "Environmental Management" },
         { _id: guidToBinData('{A708BD80-DE30-4812-985D-4B6D9BE68916}'), Name: "Human Rights/Labor Standards" },
         { _id: guidToBinData('{343C2FE4-7C64-4FDC-8FB8-2A6D5371BF0D}'), Name: "Supply Chain Management" },
         { _id: guidToBinData('{33B56601-54C7-481A-A360-6CDCF27354D4}'), Name: "Water" }
 ],
     { ordered: true }
 );


